<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateSStuTaskInfo extends Migration {
	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up() {
		Schema::create('s_stu_task_info', function (Blueprint $table) {

			$table->increments('id');
			$table->integer('user_id')->comment("学生id")->index();
			$table->integer('task_id')->comment("任务id")->index();
			$table->integer('teacher_id')->comment("老师id")->index();
			$table->integer('admin_id')->comment("操作人id")->index();
			$table->integer('feed_back_id')->comment("反馈id")->index();

			$table->integer('status')->comment("状态, 0:等待学生提交答案，1，学生提交，带后台人员审核。 11,结束，后台人员点评。21，分配给老师，带点评。22，结束，老师已点评");

			$table->text('content')->comment("提交内容");
			$table->string('pics', 1000)->comment("图片(最多四张，json字符串)");
			$table->string('voices', 1000)->comment("音频路径");

			$table->text('evaluation')->comment("批改内容");

			$table->dateTime('audit_time')->comment("审核时间");
			$table->dateTime('eva_time')->comment("点评时间");

			$table->timestamps();
			$table->SoftDeletes();
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down() {
		//
	}
}
